select * from products where pro_name like '%Spring%dresses%' or pro_des like '%Spring%dresses%'union all select * from products where (pro_name like '%Spring%' or pro_des like '%Spring%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%Spring%dresses%' or pro_des not like '%Spring%dresses%')

Apple Green Strapless Long Quinceanera Dress with Appliques 2013

Appliqued Coral Red Taffeta Quinceanera Dress with Pick ups 2013

Lavender Off Shoulder Quinceanera Dress with Appliques and Flowers

Beaded Corset Pick ups Taffeta Quinceanera Dress in Royal Blue

Spring Green Halter Quinceanera Dress with Appliques and Pick ups

Appliqued Waist Sweetheart Quinceanera Gowns in Apple Green 2013

Appliques and Pick ups Accent Quinceanera Gowns in Spring Green

Appliques Accent Halter Organza Quinceanera Gowns in Rose Pink

Flowers One Shoulder Beading Quinceanera Gowns in Hunter Green

Beaded Bodice Purple Quinceanera Gown Dresses with Puffy Ruffles

Fuchsia Organza Quinceanera Gown Dresses with Beading Pick ups

Olive Green Halter Quinceanera Gown Dresses with Pick ups Appliques

Appliqued and Ruffled Sweetheart Lavender Quinceanera Gown Dress

Flowers Ruffled Layers Accent Quinceanera Gown Dress in Light Blue

Embroidered Strapless Organza Quinceanera Gown with Ruffles

Olive Green Taffeta Quinceanera Gown with Appliques and Pick ups

Embroidery and Flowers Accent Quinceanera Gowns in Royal Blue

Flowery One Shoulder Flouncing Quinceanera Gowns in Bud Green

Flowery Frilly Taffeta and Organza Watermelon Quinceanera Gown

Embroidered Blue Ball Gown Quinces Dresses with Strapless Ruffles

Appliqued and Ruffled One Shoulder Quinces Dresses in Apple Green

White and Blue Strapless Quinces Dresses with Beautiful Embroidery

Beading and Ruches Accent Spring Green Flowery Quinces Dresses

Ruffled and Appliqued Quinces Dresses in White and Lavender 2013

Colorful Quinceanera Dresses with Appliques and Ruffles

Purple and Black Quinceanera Dresses with Appliques and Ruffles The Academy Awards

Pick ups and Appliques Accent Quinceanera Dresses in Lavender

Appliqued Lavender Organza Quinceanera Dresses with Ruffled Layers

Fuchsia Brush Train Quinceanera Dresses with Ruches Rolling Flowers

The Best Blue Quinceanera Dress with Beading and Ruffles